import openpyxl
import random

myBook=openpyxl.load_workbook('员工表.xlsx',data_only=True)

mySheet=myBook.active
myValues=list(mySheet.values)[1:]
myNewBook=openpyxl.Workbook()
myNewSheet=myNewBook.active
myNewSheet.title='员工表'
myNewSheet.append(['工号','部门','姓名','最高学历','专业','出生年份','出生月份','出生日'])
random.shuffle(myValues)
for myRow in myValues:
	myNewSheet.append(myRow)
myNewBook.save('结果表-员工表.xlsx')